-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesFishArchive`
--

CREATE TABLE IF NOT EXISTS `CodesFishArchive` (
  `FishCode` text NOT NULL,
  `FishSpecie` text NOT NULL,
  `FishName` text NOT NULL,
  `FishSampling` text NOT NULL,
  `FishMort` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesFishArchive`
--

INSERT INTO `CodesFishArchive` (`FishCode`, `FishSpecie`, `FishName`, `FishSampling`, `FishMort`) VALUES
('1', 'Specie ???', 'Stock ???', '', 'I'),
('BCP', 'Specie ???', 'Black carp', 'K', ''),
('BV', 'Specie ???', 'Bivalve', '', ''),
('C', 'Specie ???', 'Stock ???', '', 'C'),
('CARP', 'Cyprinus carpio', 'Common carp', '', ''),
('CCP', 'Cyprinus carpio', 'Common carp', 'I,K', ''),
('CHA', 'Chanos chanos', 'Milkfish', 'G', ''),
('CICH1', 'All tilapia species', 'Smaller fish size of two-size stocking', 'F', ''),
('CICH2', 'All tilapia species', 'Larger fish size of two-size stocking', 'F', ''),
('CICHL', 'Cichlasoma managuense', 'Guapote tigre', 'F', 'F'),
('COLOS', 'Colossoma macropomum', 'Cachama (Columbia), tambaqui (Brazil)', 'F', ''),
('FRY', 'All species', 'Fish, fry', '', ''),
('GARIE', 'Clarias gariepinus', 'Clarias', 'K,P', ''),
('GCP', 'Specie ???', 'Grass carp', '', ''),
('GIFT', 'Oreochromis niloticus', 'Tilapia, genetic. improv. farmed tilapia (GIFT)', '', ''),
('GMT', 'Oreochromis niloticus ???', 'Tilapia, genetic. prod. male using YY males', '', ''),
('HOR', 'Oreochromis hornorum', 'Hornorum tilapia', '', ''),
('HSM', 'All tilapia species', 'Tilapia, hand selected male (HSM)', '', ''),
('JUV', 'All species', 'Fish or shrimp, juvenille', '', ''),
('M X G', 'Clarias macrocephalus x C. gariepinus', 'Hybrid clarius', 'C', 'C'),
('MILK', 'Chanos chanos', 'Milkfish', '', ''),
('MON', 'Penaeus monodon', 'Shrimp', 'G', 'G'),
('MS', 'All tilapia species', 'Tilapia, mixed sex', '', ''),
('MTIL', 'Specie ???', 'Stock ???', 'K', ''),
('MUL', 'Mugil curema', 'Mullet', 'K', ''),
('N X H', 'O. niloticus female x O. hornorum male', 'Tilapia, for genetic male fish production', '', ''),
('NIL', 'Oreochromis niloticus', 'Nile tilapia', 'B,C,E,F,G,H,I,K,P', 'B,C,G,H,I'),
('NODAT', 'Not defined, missing data', 'Not defined, missing data', 'P', 'F,I'),
('NONE', 'Not defined, null data', 'Not defined, null data', '', ''),
('PL', 'All shrimp species', 'Shrimp, post larvae', '', ''),
('SCP', 'Specie ???', 'Stock ???', '', ''),
('SRM', 'All tilapia species', 'Tilapia, sex rev. male (SRM) via hormone', '', ''),
('STRIA', 'Channa striata', 'Stock ???', 'P', ''),
('STY', 'Penaeus stylirostis', 'Shrimp', 'A', ''),
('TN', 'Oreochromis niloticus ???', 'tilapia nilotica???', 'F', 'F'),
('TNRED', 'Oreochromis niloticus ???', 'red tilapia nilotica???', 'F', ''),
('VAN', 'Penaeus vannamei', 'Shrimp', 'A', ''),
('YYSUP', 'Specie ???', 'Tilapia, double Y supermales', '', ''),
('ZIL', 'Oreochromis zilliei', 'Zilli tilapia', 'K', '');
